
CREATE PROCEDURE [dbo].[RollDice] 

AS
BEGIN 
	Declare @dice1 int
	Declare @dice2 int
	SET @dice1 = (SELECT [dbo].[RandNumber]() As dice)
	SET @dice2 = (SELECT [dbo].[RandNumber]() As dice)

	SELECT @dice1 As dice1,@dice2 As dice2
END

-- [dbo].[RollDice]